Job History View
The Job History view displays the list of all jobs that have been run or are running at the moment.
There are different Job types
-
Cleanup job:
a system Job to clean stale Replication Tables.
-
Optimization job:
copies data from Data Source tables that are targeted by an Optimization fully or incrementally. It can be created in the Optimization View
-
Statistical job:
gathers a Data Source's statistics, such as row & column cardinalities to calculate Optimizations. It can be created in the Data Explorer
-
SQL job:
executes a predefined SQL script or statement.
Jobs can be scheduled to run once or periodically. Each schedule run is displayed in the Job History view. For each Job Run the user can see:
- Type of the Job
- Details
- Job id
- Optimization id
- Start and finish times
- Duration (expressed as hours:minutes:seconds.milliseconds)
- Status, whether the job finished successfully or not
To find a particular Job Execution faster, please use the text filter or the column filters.
Available text filtering options are:
- jobId= - filter by job id.
- optId= - filter by optimization id.
- no prefix - filter by SQL statement.
The column filtering can be accessed by right-clicking a particular column. Depending on the data type of the column, different filtering options will be shown and can be selected by clicking on them. Some column filters also contain a text filter that can be used to display only the rows that contain the entered text. Multiple columns can have an active filter simultaneously, in which case only rows that match the criteria of all filters will be displayed.
Job history's Pop-Up Menu
Right-click on a query to
-
Find optimization: this will find an optimization corresponding to the history record chosen and opens it in the Optimizations tab with the proper filters set.
-
Find job: this will find a job corresponding to the history record chosen and opens it in the Jobs tab with the proper filters set.
Keyword shortcuts and actions
-
Select all the Rows:
Ctrl+A
Reference manual pages:
